This document describes the report for E-WMS transaction history, when using WMS SKU Management, as available from product update 412.
This document has following sections:
Exact Globe Next menu WMS, Reports, Transaction history offers insight in WMS historical and processed transactions. This document describes the report when using E-WMS SKU Management.
When you are not using WMS SKU Management, please refer to this document.
General remarks
For SKU items, the report will also show transaction history for transactions created before release 407. For non-SKU items, transaction history is only available for transactions processed in release 407 or later. After updating to release 407 or later, and rebuilding E-WMS stock balances, stock corrections (E-WMS stock opening balance) will be created where necessary, at least for all non-SKU items, which will be visible on this report as 'Stock corrections'.
The report is sorted by:
Selections
After starting the report, you have following selections and options available:
Date Selection on the processed transaction date
Item code Selection on item code. The browser shows items of type 'standard' and 'bulk', and indicates whether the item is a SKU item or not. Item group Selection on item group
Serial/batch number Selection on serial- or batch number (only visible when your license contains SE1325 E-Serial/Batch) Warehouse Selection on warehouse. This is not limited by 'warehouse rights' for the user starting the report. Location Selection on warehouse location Location type Selection on WMS 'Location types', as defined in menu WMS, Setup, Location management, Location types
Outer SKU Selection on specific outer SKU numbers
Inner SKU Selection on specific inner SKU numbers Out.SKU type Selection on a specific outer SKU type, as defined in menu WMS, Setup, SKU, SKU types Inn.SKU type Selection on a specific inner SKU type, as defined in menu WMS, Setup, SKU, SKU types Employee Selection on the warehouse employee who scanned the transaction. The browser lists all employees, but shows employees linked to scanners first. For E-WMS Stock Inventory transactions the employee may be 0 (zero) and for correction counts, the assigned employee is always 0 (zero). Our ref. Selection on Exact Globe Next 'our reference', as assigned to this transaction on processing. The browser shows all 'our references' known in the E-WMS transaction table.
Transaction type You are able to report all WMS transaction types, or show one specific transaction type. "Stock transaction" refers to the stock receipts or issues processed through E-WMS menu WMS, To be processed, Stock transactions (or the E-WMS RF Service). "Stock inventory" are count differences processed through the E-WMS inventory process (menu WMS, To be processed, Inventory counts). "Correction counts" are stock balance corrections, which can be created by E-WMS Inventory Counts (automatically generated when creating a new count in case of stock inconsistency), or by the E-WMS Stock Diagnose 'repair' function. "Exact Globe Next" are stock transactions processed directly in Exact Globe Next (or add-ons), outside E-WMS processes. "Corrections" refers to two types: "Correction counts" and "Exact Globe Next", so you are able to report (or exclude, see 'Exclude' below) these two types of transactions at the same time. Exclude You are able to exclude one process type from the report, see remarks above for 'Transaction type' SKU items only When enabled, the report will only show SKU items (=an item which is configured in menu WMS, Setup, SKU, SKU per item) When disabled, the report will show all items. Please also note the report option 'Hide transactions in sales units' below.
Report options
The following reporting options are available. Sort by You can use these key fields to sort the report. 'Month' refers to the year and month of the transaction date (15 December 2013 would result in "2013-12"). Show: Subtotal When enabled, the report will show group headers and subtotals per 'Sort by' field. These subtotals include: total quantity in sales units, number of transactions, number of SKUs involved in the listed transactions. When disabled, the report will show no subtotals and no group headers, but only one report totals. The listing is still sorted on the 'Sort by' field.
Show: SKU details When enabled, the report will show the content of a SKU, which can be: inner SKU numbers (in case of a two-layer SKU) and/or serial numbers. When disabled, the report will just show totals per outer SKU number. Note: an inner SKU when not part of an outer SKU, is regarded as 'outer SKU' for this report (and the SKU number will show in column 'SKU').
Show: transactions in sales units When enabled, transactions for all unit types are listed. When disabled, transactions without SKU number (transactions for SKU items with empty SKU number, or transactions for non-SKU items) are not shown in the report. Please note, when disabled, you may see only one part of a 'transfer' or repacking action, if a bulk SKU was transferred to a location where it was 'broken up' to sales units.
Report columns
After pressing 'Start', the report will be generated, and shows following columns: SKU The SKU number for the outer SKU, or for the inner SKU when not part of a two-layer SKU configuration. Item code, Item description The item used in the transaction. Available space for long item codes and item descriptions is limited. Serial/batch The serial batch number, for serial number- or batch items Date The transaction date Wrh. The warehouse code Location The warehouse location
Type Refers to the E-WMS transaction type. This transaction type code is explained in the footer of the report:
A - Replenishment H - Purchase Entry I - Stock inventory K - Production - Issues O - Fulfilment P - Production - Receipts R - Receipts registration S - Stock transactions T - Sales Entry (Mobile Sales) V - Stock transfers (including repacking) X - Correction counts G - Exact Globe Next
Before release 412, type 'Stock Inventory' also includes all transactions processed directly in Exact Globe Next instead of through E-WMS. In these cases the column 'Employee' would be empty. From release 412, these transactions are reported separately as transaction type 'Exact Globe Next'. Our ref. The Exact Globe Next 'our reference' number assigned to the transaction, when processed by E-WMS. This column can be empty in case of 'correction counts' (inconsistency repair transactions), or for transaction type 'Transfers': repacking of a SKU (since this means no stock movement in Exact Globe Next). You can use this 'our reference' number to search the created transactions in Exact Globe Next. User The full name of the hand terminal user who scanned the transaction. This column will be empty for transaction types 'Correction count' and 'Exact Globe Next'. This column can also be empty for 'Stock Inventory' transactions, because these stock corrections can be based on combined counts of multiple scanners. Quantity The item quantity in standard sales units, using 3 decimals for divisible items, else without decimals.
Totals
Total quantity The total quantity in sales units, using 3 decimals if a divisible item was part of the list, else without decimals. Number of SKUs The count of unique SKU numbers in the selected transactions. On subtotal level, this is only shown for SKU items. Number of transactions The total number of transactions for the selected range. For transfers, each issue and receipt of a transfer is counted as a separate transaction.